<html>
<head>
<title>DatabaseQueryStrings.java</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">
.ln { color: rgb(0,0,0); font-weight: normal; font-style: normal; }
.s0 { color: rgb(0,0,128); font-weight: bold; }
.s1 { }
.s2 { color: rgb(128,128,128); font-style: italic; }
.s3 { color: rgb(0,128,0); font-weight: bold; }
</style>
</head>
<BODY BGCOLOR="#ffffff">
<TABLE CELLSPACING=0 CELLPADDING=5 COLS=1 WIDTH="100%" BGCOLOR="#C0C0C0" >
<TR><TD><CENTER>
<FONT FACE="Arial, Helvetica" COLOR="#000000">
DatabaseQueryStrings.java</FONT>
</center></TD></TR></TABLE>
<pre>

<span class="s0">package </span><span class="s1">com.example.lista_zakupow.database.utils.query; 
 
</span><span class="s0">import </span><span class="s1">com.example.lista_zakupow.database.utils.tables_headers.ListaZakupowTableHeaders; 
</span><span class="s0">import </span><span class="s1">com.example.lista_zakupow.database.utils.tables_headers.ProduktyTableHeaders; 
 
</span><span class="s0">public class </span><span class="s1">DatabaseQueryStrings { 
    </span><span class="s2">// Polecenia SQL do tworzenia i usuwania tabel.</span><span class="s1"> 
    </span><span class="s0">public static final </span><span class="s1">String CREATE_LIST_TABLE = 
            </span><span class="s3">&quot;CREATE TABLE IF NOT EXISTS &quot; </span><span class="s1">+ ListaZakupowTableHeaders.TABLE_NAME + 
                    </span><span class="s3">&quot;(&quot; </span><span class="s1">+ 
                    ListaZakupowTableHeaders.LIST_ID + </span><span class="s3">&quot; INTEGER PRIMARY KEY AUTOINCREMENT, &quot; </span><span class="s1">+ 
                    ListaZakupowTableHeaders.LIST_NAME + </span><span class="s3">&quot; TEXT&quot; </span><span class="s1">+ 
                    </span><span class="s3">&quot;);&quot;</span><span class="s1">; 
 
 
    </span><span class="s2">// Usuwanie tabel</span><span class="s1"> 
    </span><span class="s0">public static final </span><span class="s1">String DROP_LIST_TABLE = 
            </span><span class="s3">&quot;DROP TABLE IF EXISTS &quot; </span><span class="s1">+ ListaZakupowTableHeaders.TABLE_NAME + </span><span class="s3">&quot;;&quot;</span><span class="s1">; 
 
    </span><span class="s0">public static final </span><span class="s1">String CREATE_PRODUCTS_TABLE = 
            </span><span class="s3">&quot;CREATE TABLE IF NOT EXISTS &quot; </span><span class="s1">+ ProduktyTableHeaders.TABLE_NAME + 
                    </span><span class="s3">&quot;(&quot; </span><span class="s1">+ 
                    ProduktyTableHeaders.PRODUCT_ID + </span><span class="s3">&quot; INTEGER PRIMARY KEY AUTOINCREMENT, &quot; </span><span class="s1">+ 
                    ProduktyTableHeaders.PRODUCT_NAME + </span><span class="s3">&quot; TEXT, &quot; </span><span class="s1">+ 
                    ProduktyTableHeaders.HOW_MANY + </span><span class="s3">&quot; DECIMAL NOT NULL, &quot; </span><span class="s1">+ 
                    ProduktyTableHeaders.UNIT + </span><span class="s3">&quot; TEXT, &quot; </span><span class="s1">+ 
                    ProduktyTableHeaders.LIST_ID + </span><span class="s3">&quot; INTEGER NOT NULL&quot; </span><span class="s1">+ 
                    </span><span class="s3">&quot;);&quot;</span><span class="s1">; 
 
 
    </span><span class="s2">// Usuwanie tabel</span><span class="s1"> 
    </span><span class="s0">public static final </span><span class="s1">String DROP_PRODUCTS_TABLE = 
            </span><span class="s3">&quot;DROP TABLE IF EXISTS &quot; </span><span class="s1">+ ProduktyTableHeaders.TABLE_NAME + </span><span class="s3">&quot;;&quot;</span><span class="s1">; 
 
 
} 
</span></pre>
</body>
</html>